`:top

`!SQL CLR`! or `!SQLCLR`! (`F33f`_`[SQL`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=SQL]`_`f `F33f`_`[Common Language Runtime`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Common_Language_Runtime]`_`f) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows `F33f`_`[managed code`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Managed_code]`_`f to be hosted by, and run in, the `F33f`_`[Microsoft SQL Server`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Microsoft_SQL_Server]`_`f environment.

This technology, introduced in Microsoft SQL Server 2005, allow users for example to create the following types of managed code objects in SQL Server in .NET languages such as `F33f`_`[C#`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=C_Sharp_(programming_language)]`_`f or `F33f`_`[VB.NET`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=VB.NET]`_`f.

• `F33f`_`[Stored procedures`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Stored_procedure]`_`f (SPs) which are analogous to `*procedures`* or `*void functions`* in procedural languages like VB or C,

• `F33f`_`[Triggers`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Database_trigger]`_`f which are stored procedures that fire in response to `F33f`_`[Data Manipulation Language`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Data_Manipulation_Language]`_`f (DML) or `F33f`_`[Data Definition Language`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Data_Definition_Language]`_`f (DDL) events,

• `F33f`_`[User-defined functions`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=User-defined_function]`_`f (UDFs) which are analogous to functions in procedural languages,

• User-defined aggregates (UDAs) which allow developers to create custom aggregates that act on sets of data instead of one row at a time,

• `F33f`_`[User-defined types`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=User-defined_type]`_`f (UDTs) that allow users to create simple or complex data types which can be serialized and deserialized within the database.

The SQL CLR relies on the creation, deployment, and registration of `F33f`_`[CLI assemblies`:/page/wikibook/entry.mu`zim=wikipedia_en_all_nopic_2025-08.zim|entry_path=Assembly_(CLI)]`_`f, which are physically stored in managed code dynamic load libraries (DLLs). These assemblies may contain CLI namespaces, classes, functions and properties.

>>External links

• Microsoft Docs: Common Language Runtime Integration Overview (Latest version)

• MSDN: Using CLR Integration in SQL Server 2005 (Provides the perspective at the time of the initial release.)

`c`F0af`_`[↑ Back to top`#top]`_`f`a